package jpa.entitys.synchro.staging;

import java.io.Serializable;

import javax.persistence.*;

import java.util.Date;


/**
 * The persistent class for the MM_LIVCONTRACTOR_OUTB database table.
 * 
 */
@Entity
@Table(name="MM_LIVCONTRACTOR_OUTB")
@NamedQueries({
    @NamedQuery(name = "MmLivcontractorOutb.findAll", query = " SELECT c FROM MmLivcontractorOutb c"),
    @NamedQuery(name = "MmLivcontractorOutb.findById", query = " SELECT c FROM MmLivcontractorOutb c WHERE c.promisStagingId = :Id"),
    @NamedQuery(name = "MmLivcontractorOutb.findByInstanceNo", query = " SELECT c FROM MmLivcontractorOutb c WHERE c.instanceNo = :instanceNo And c.issync = 'N' order by c.company,c.project,c.documentNo,c.status,c.installmentNumber asc"),
    @NamedQuery(name = "MmLivcontractorOutb.findAllIsSync", query = " SELECT c FROM MmLivcontractorOutb c WHERE c.issync = :issync order by c.instanceNo asc"),
    @NamedQuery(name = "MmLivcontractorOutb.findByDocumentNo", query = " SELECT c FROM MmLivcontractorOutb c WHERE c.company = :company And c.project = :project And c.documentNo = :documentNo And c.status = :status And c.issync = :issync order by c.instanceNo,c.company,c.project,c.documentNo,c.status,c.installmentNumber asc")
    })
public class MmLivcontractorOutb extends jpa.entitys.synchro.common.CommonEntity implements Serializable {
	private static final long serialVersionUID = 1L;

	@Id
	@Column(name="PROMIS_STAGING_ID", unique=true, nullable=false, length=100)
	private String promisStagingId;

	@Override public String toString() { return org.apache.commons.lang.builder.ToStringBuilder.reflectionToString(this);}
	
	@Column(name="ACTION_HANDLER", length=20)
	private String actionHandler;

	@Column(name="ACTUAL_WORK_COMPLETED", length=10)
	private String actualWorkCompleted;

	@Column(length=100)
	private String company;

	@Column(name="CONTR_GUARANTEE_AMOUNT", length=30)
	private String contrGuaranteeAmount;

	@Column(name="CREATED_BY", length=30)
	private String createdBy;

	@Column(name="CREATED_ON", length=20)
	private String createdOn;

	@Column(length=10)
	private String currency;

	@Column(name="EXT_REF_KEY", length=100)
	private String extRefKey;

	@Column(name="EXT_REF_NO", length=100)
	private String extRefNo;

	@Column(length=30)
	private String fee;

	@Column(name="INSTALLMENT_AMOUNT", length=30)
	private String installmentAmount;

	@Column(name="INSTALLMENT_NUMBER", length=10)
	private Long installmentNumber;

	@Column(name="INSTANCE_NO", length=100)
	private String instanceNo;

	@Column(length=1)
	private String isactive;

	@Column(length=1)
	private String issync;

	@Column(name="MSG_ACT_RESULT", length=3707)
	private String msgActResult;

	@Column(name="MSG_ALT_DESC", length=3700)
	private String msgAltDesc;

	@Column(name="MSG_CODE", length=1500)
	private String msgCode;

	@Column(name="MSG_DESC", length=3700)
	private String msgDesc;

	@Column(name="PAYMENT_AMOUNT", length=30)
	private String paymentAmount;

	@Column(name="PENALTY_AMOUNT", length=30)
	private String penaltyAmount;

	@Column(name="PO_DEDUCT_AMOUNT", length=30)
	private String poDeductAmount;

	@Column(length=30)
	private String project;

	@Column(name="REF_CONTRACT_NO", length=100)
	private String refContractNo;

	@Column(name="REF_INVOICE_NO", length=100)
	private String refInvoiceNo;

	@Column(name="REQUEST_DATE", length=10)
	private String requestDate;

	@Column(name="REQUEST_NO", length=100)
	private String requestNo;

	@Column(name="RETENTION_AMOUNT", length=30)
	private String retentionAmount;

	@Column(name="SAP_COMPANY_CODE", length=4)
	private String sapCompanyCode;

	@Column(name="SAP_PLANT_CODE", length=4)
	private String sapPlantCode;

	@Column(name="SYNC_CREATEDBY", length=100)
	private String syncCreatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_CREATEDON")
	private Date syncCreatedon;

	@Column(name="SYNC_UPDATEDBY", length=100)
	private String syncUpdatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_UPDATEDON")
	private Date syncUpdatedon;

	@Column(name="TAX_TYPE", length=10)
	private String taxType;

	@Column(name="UNIT_NUMBER", length=100)
	private String unitNumber;

	@Column(name="UPDATED_BY", length=30)
	private String updatedBy;

	@Column(name="UPDATED_ON", length=20)
	private String updatedOn;
	
	@Column(name="PO_DIS_AMOUNT", length=30)
	private String poDisAmount;
	
	@Column(name="REF_TYPE", length=100)
	private String refType;
	
	@Column(name="STATUS", length=100)
	private String status;
	
	@Column(name="DOCUMENT_NO", length=100)
	private String documentNo;
	
	@Column(name="BUILDING_CODE", length=100)
	private String buildingCode;
	
	@Column(name="INTERFACE_NO", length=100)
	private String interfaceNo;	
	
	@Column(name="REF_SYNC_PK_ID", length=100)
	private String refSyncPkId;
	
	@Column(name="PO_ADD_AMOUNT", length=100)
	private String poAddAmount;
	
//	@Column(name="RMS_IS_PAID", length=100)
//	private String rmsIsPaid;
	
	@Column(name="PAYABLE_FLAG")
	private String payableFlag;
	
	@Column(name="RETU_CONTR_GUARA_FLAG")
	private String returnContractGuaranteeFlag;
	
	@Column(name="CONT_UNIT_SEQ")
	private String contUnitSeq;
	
	@Column(name="INSTALLMENT_NUMBER_STR")
	private String installmentNumberStr;
	
	@Column(name="LINE_INST_KEY")
	private String lineInstKey;	
	
    /**
	 * @return the lineInstKey
	 */
	public String getLineInstKey() {
		return lineInstKey;
	}

	/**
	 * @param lineInstKey the lineInstKey to set
	 */
	public void setLineInstKey(String lineInstKey) {
		this.lineInstKey = lineInstKey;
	}
	
    /**
	 * @return the installmentNumberStr
	 */
	public String getInstallmentNumberStr() {
		return installmentNumberStr;
	}

	/**
	 * @param installmentNumberStr the installmentNumberStr to set
	 */
	public void setInstallmentNumberStr(String installmentNumberStr) {
		this.installmentNumberStr = installmentNumberStr;
	}

	/**
	 * @return the contUnitSeq
	 */
	public String getContUnitSeq() {
		return contUnitSeq;
	}

	/**
	 * @param contUnitSeq the contUnitSeq to set
	 */
	public void setContUnitSeq(String contUnitSeq) {
		this.contUnitSeq = contUnitSeq;
	}

	/**
	 * @return the payableFlag
	 */
	public String getPayableFlag() {
		return payableFlag;
	}

	/**
	 * @param payableFlag the payableFlag to set
	 */
	public void setPayableFlag(String payableFlag) {
		this.payableFlag = payableFlag;
	}

	/**
	 * @return the returnContractGuaranteeFlag
	 */
	public String getReturnContractGuaranteeFlag() {
		return returnContractGuaranteeFlag;
	}

	/**
	 * @param returnContractGuaranteeFlag the returnContractGuaranteeFlag to set
	 */
	public void setReturnContractGuaranteeFlag(String returnContractGuaranteeFlag) {
		this.returnContractGuaranteeFlag = returnContractGuaranteeFlag;
	}

//	/**
//	 * @return the rmsIsPaid
//	 */
//	public String getRmsIsPaid() {
//		return rmsIsPaid;
//	}
//
//	/**
//	 * @param rmsIsPaid the rmsIsPaid to set
//	 */
//	public void setRmsIsPaid(String rmsIsPaid) {
//		this.rmsIsPaid = rmsIsPaid;
//	}

	/**
	 * @return the poAddAmount
	 */
	public String getPoAddAmount() {
		return poAddAmount;
	}

	/**
	 * @param poAddAmount the poAddAmount to set
	 */
	public void setPoAddAmount(String poAddAmount) {
		this.poAddAmount = poAddAmount;
	}

	/**
	 * @return the refSyncPkId
	 */
	public String getRefSyncPkId() {
		return refSyncPkId;
	}

	/**
	 * @param refSyncPkId the refSyncPkId to set
	 */
	public void setRefSyncPkId(String refSyncPkId) {
		this.refSyncPkId = refSyncPkId;
	}

	/**
	 * @return the interfaceNo
	 */
	public String getInterfaceNo() {
		return interfaceNo;
	}

	/**
	 * @param interfaceNo the interfaceNo to set
	 */
	public void setInterfaceNo(String interfaceNo) {
		this.interfaceNo = interfaceNo;
	}
	
    /**
	 * @return the buildingCode
	 */
	public String getBuildingCode() {
		return buildingCode;
	}

	/**
	 * @param buildingCode the buildingCode to set
	 */
	public void setBuildingCode(String buildingCode) {
		this.buildingCode = buildingCode;
	}

	/**
	 * @return the status
	 */
	public String getStatus() {
		return status;
	}

	/**
	 * @param status the status to set
	 */
	public void setStatus(String status) {
		this.status = status;
	}

	/**
	 * @return the documentNo
	 */
	public String getDocumentNo() {
		return documentNo;
	}

	/**
	 * @param documentNo the documentNo to set
	 */
	public void setDocumentNo(String documentNo) {
		this.documentNo = documentNo;
	}

	/**
	 * @return the refType
	 */
	public String getRefType() {
		return refType;
	}

	/**
	 * @param refType the refType to set
	 */
	public void setRefType(String refType) {
		this.refType = refType;
	}

	/**
	 * @return the poDisAmount
	 */
	public String getPoDisAmount() {
		return poDisAmount;
	}

	/**
	 * @param poDisAmount the poDisAmount to set
	 */
	public void setPoDisAmount(String poDisAmount) {
		this.poDisAmount = poDisAmount;
	}

	public MmLivcontractorOutb() {
    }

	public String getPromisStagingId() {
		return this.promisStagingId;
	}

	public void setPromisStagingId(String promisStagingId) {
		this.promisStagingId = promisStagingId;
		super.setPromisStagingId(promisStagingId);
	}

	public String getActionHandler() {
		return this.actionHandler;
	}

	public void setActionHandler(String actionHandler) {
		this.actionHandler = actionHandler;
	}

	public String getActualWorkCompleted() {
		return this.actualWorkCompleted;
	}

	public void setActualWorkCompleted(String actualWorkCompleted) {
		this.actualWorkCompleted = actualWorkCompleted;
	}

	public String getCompany() {
		return this.company;
	}

	public void setCompany(String company) {
		this.company = company;
	}

	public String getContrGuaranteeAmount() {
		return this.contrGuaranteeAmount;
	}

	public void setContrGuaranteeAmount(String contrGuaranteeAmount) {
		this.contrGuaranteeAmount = contrGuaranteeAmount;
	}

	public String getCreatedBy() {
		return this.createdBy;
	}

	public void setCreatedBy(String createdBy) {
		this.createdBy = createdBy;
	}

	public String getCreatedOn() {
		return this.createdOn;
	}

	public void setCreatedOn(String createdOn) {
		this.createdOn = createdOn;
	}

	public String getCurrency() {
		return this.currency;
	}

	public void setCurrency(String currency) {
		this.currency = currency;
	}

	public String getExtRefKey() {
		return this.extRefKey;
	}

	public void setExtRefKey(String extRefKey) {
		this.extRefKey = extRefKey;
	}

	public String getExtRefNo() {
		return this.extRefNo;
	}

	public void setExtRefNo(String extRefNo) {
		this.extRefNo = extRefNo;
	}

	public String getFee() {
		return this.fee;
	}

	public void setFee(String fee) {
		this.fee = fee;
	}

	public String getInstallmentAmount() {
		return this.installmentAmount;
	}

	public void setInstallmentAmount(String installmentAmount) {
		this.installmentAmount = installmentAmount;
	}

	public Long getInstallmentNumber() {
		return this.installmentNumber;
	}

	public void setInstallmentNumber(Long installmentNumber) {
		this.installmentNumber = installmentNumber;
	}

	public String getInstanceNo() {
		return this.instanceNo;
	}

	public void setInstanceNo(String instanceNo) {
		this.instanceNo = instanceNo;
	}

	public String getIsactive() {
		return this.isactive;
	}

	public void setIsactive(String isactive) {
		this.isactive = isactive;
	}

	public String getIssync() {
		return this.issync;
	}

	public void setIssync(String issync) {
		this.issync = issync;
	}

	public String getMsgActResult() {
		return this.msgActResult;
	}

	public void setMsgActResult(String msgActResult) {
		this.msgActResult = msgActResult;
	}

	public String getMsgAltDesc() {
		return this.msgAltDesc;
	}

	public void setMsgAltDesc(String msgAltDesc) {
		this.msgAltDesc = msgAltDesc;
	}

	public String getMsgCode() {
		return this.msgCode;
	}

	public void setMsgCode(String msgCode) {
		this.msgCode = msgCode;
	}

	public String getMsgDesc() {
		return this.msgDesc;
	}

	public void setMsgDesc(String msgDesc) {
		this.msgDesc = msgDesc;
	}

	public String getPaymentAmount() {
		return this.paymentAmount;
	}

	public void setPaymentAmount(String paymentAmount) {
		this.paymentAmount = paymentAmount;
	}

	public String getPenaltyAmount() {
		return this.penaltyAmount;
	}

	public void setPenaltyAmount(String penaltyAmount) {
		this.penaltyAmount = penaltyAmount;
	}

	public String getPoDeductAmount() {
		return this.poDeductAmount;
	}

	public void setPoDeductAmount(String poDeductAmount) {
		this.poDeductAmount = poDeductAmount;
	}

	public String getProject() {
		return this.project;
	}

	public void setProject(String project) {
		this.project = project;
	}

	public String getRefContractNo() {
		return this.refContractNo;
	}

	public void setRefContractNo(String refContractNo) {
		this.refContractNo = refContractNo;
	}

	public String getRefInvoiceNo() {
		return this.refInvoiceNo;
	}

	public void setRefInvoiceNo(String refInvoiceNo) {
		this.refInvoiceNo = refInvoiceNo;
	}

	public String getRequestDate() {
		return this.requestDate;
	}

	public void setRequestDate(String requestDate) {
		this.requestDate = requestDate;
	}

	public String getRequestNo() {
		return this.requestNo;
	}

	public void setRequestNo(String requestNo) {
		this.requestNo = requestNo;
	}

	public String getRetentionAmount() {
		return this.retentionAmount;
	}

	public void setRetentionAmount(String retentionAmount) {
		this.retentionAmount = retentionAmount;
	}

	public String getSapCompanyCode() {
		return this.sapCompanyCode;
	}

	public void setSapCompanyCode(String sapCompanyCode) {
		this.sapCompanyCode = sapCompanyCode;
	}

	public String getSapPlantCode() {
		return this.sapPlantCode;
	}

	public void setSapPlantCode(String sapPlantCode) {
		this.sapPlantCode = sapPlantCode;
	}

	public String getSyncCreatedby() {
		return this.syncCreatedby;
	}

	public void setSyncCreatedby(String syncCreatedby) {
		this.syncCreatedby = syncCreatedby;
	}

	public Date getSyncCreatedon() {
		return this.syncCreatedon;
	}

	public void setSyncCreatedon(Date syncCreatedon) {
		this.syncCreatedon = syncCreatedon;
	}

	public String getSyncUpdatedby() {
		return this.syncUpdatedby;
	}

	public void setSyncUpdatedby(String syncUpdatedby) {
		this.syncUpdatedby = syncUpdatedby;
	}

	public Date getSyncUpdatedon() {
		return this.syncUpdatedon;
	}

	public void setSyncUpdatedon(Date syncUpdatedon) {
		this.syncUpdatedon = syncUpdatedon;
	}

	public String getTaxType() {
		return this.taxType;
	}

	public void setTaxType(String taxType) {
		this.taxType = taxType;
	}

	public String getUnitNumber() {
		return this.unitNumber;
	}

	public void setUnitNumber(String unitNumber) {
		this.unitNumber = unitNumber;
	}

	public String getUpdatedBy() {
		return this.updatedBy;
	}

	public void setUpdatedBy(String updatedBy) {
		this.updatedBy = updatedBy;
	}

	public String getUpdatedOn() {
		return this.updatedOn;
	}

	public void setUpdatedOn(String updatedOn) {
		this.updatedOn = updatedOn;
	}

}